Dataset info
| Number of variables | 40 |
|---|---|
| Number of observations | 13525 |
| Missing cells | 100681 (18.6%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 4.1 MiB |
| Average record size in memory | 320.0 B |
Variables types
| Numeric | 8 |
|---|---|
| Categorical | 14 |
| Boolean | 11 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 6 |
| Unsupported | 0 |
Warnings
Black.Friday has 5950 (44.0%) missing values | Missing |
Christmas.Flag has 5950 (44.0%) missing values | Missing |
Discount_final has a high cardinality: 71 distinct values | Warning |
Event has 12727 (94.1%) missing values | Missing |
FB_Spends has 5429 (40.1%) zeros | Zeros |
FB_Spends_Adstock_0.173 is highly correlated with FB_Spends (ρ = 0.9913990349) | Rejected |
Festival.Flag has 5950 (44.0%) missing values | Missing |
Fiscal_Week is highly correlated with Fiscal_Month (ρ = 0.9966852518) | Rejected |
Free.Trial.Week has 5950 (44.0%) missing values | Missing |
Free.Trial.Week.Lag1 has 5950 (44.0%) missing values | Missing |
Free.Trial.Week.Lag2 has 11724 (86.7%) missing values | Missing |
game_name has constant value "Mortal Kombat 11" | Rejected |
geo_region has constant value "North America" | Rejected |
Halloween has 5950 (44.0%) missing values | Missing |
Holiday has 5950 (44.0%) missing values | Missing |
New_Week_Since_Launch is highly correlated with days_since_launch (ρ = 0.9998798641) | Rejected |
Post.Holiday.Flag has 5950 (44.0%) missing values | Missing |
Pre.Holiday.Flag has 5950 (44.0%) missing values | Missing |
Price has 11724 (86.7%) missing values | Missing |
Promo has 10774 (79.7%) missing values | Missing |
pweek has a high cardinality: 2178 distinct values | Warning |
revenue_usd is highly skewed (γ1 = 21.3810817) | Skewed |
transaction_date has a high cardinality: 483 distinct values | Warning |
units_base has 182 (1.3%) missing values | Missing |
units_sold is highly correlated with revenue_usd (ρ = 0.9636180616) | Rejected |
asp_new
Numeric
| Distinct count | 7537 |
|---|---|
| Unique (%) | 55.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 42.04411673 |
|---|---|
| Minimum | 3.9641 |
| Maximum | 252.189 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3.9641 |
|---|---|
| 5-th percentile | 16.03621327 |
| Q1 | 27.73038333 |
| Median | 41.993 |
| Q3 | 62.3525 |
| 95-th percentile | 70.33503792 |
| Maximum | 252.189 |
| Range | 248.2249 |
| Interquartile range | 34.62211667 |
Descriptive statistics
| Standard deviation | 18.52068936 |
|---|---|
| Coef of variation | 0.4405060874 |
| Kurtosis | 0.7757323968 |
| Mean | 42.04411673 |
| MAD | 14.94142997 |
| Skewness | 0.5257290451 |
| Sum | 568646.6787 |
| Variance | 343.0159343 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 3.9641 8.827 8.93153692 10.36190526 10.51907219 ... 73.91218782 73.91226818 75.853883 87.4055 252.189 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 41.993 | 1162 | 8.6% | |
| 27.993 | 1001 | 7.4% | |
| 69.993 | 831 | 6.1% | |
| 62.993 | 353 | 2.6% | |
| 16.793 | 119 | 0.9% | |
| 25.193 | 102 | 0.8% | |
| 31.493 | 79 | 0.6% | |
| 11.193 | 63 | 0.5% | |
| 50.393 | 63 | 0.5% | |
| 37.793 | 58 | 0.4% | |
| Other values (7527) | 9694 | 71.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3.9641 | 1 | < 0.1% | |
| 4.193 | 2 | < 0.1% | |
| 7.9604 | 1 | < 0.1% | |
| 8.1165 | 1 | < 0.1% | |
| 8.14048 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 252.189 | 1 | < 0.1% | |
| 176.393 | 2 | < 0.1% | |
| 167.993 | 1 | < 0.1% | |
| 119.693 | 5 | < 0.1% | |
| 104.412 | 1 | < 0.1% |
base_asp
Numeric
| Distinct count | 33 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 47.62926998 |
|---|---|
| Minimum | 3.9641 |
| Maximum | 73.96371903 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3.9641 |
|---|---|
| 5-th percentile | 26.03813545 |
| Q1 | 28.24724427 |
| Median | 41.99333519 |
| Q3 | 67.75479812 |
| 95-th percentile | 72.69908693 |
| Maximum | 73.96371903 |
| Range | 69.99961903 |
| Interquartile range | 39.50755385 |
Descriptive statistics
| Standard deviation | 17.30313431 |
|---|---|
| Coef of variation | 0.3632878335 |
| Kurtosis | -1.440557296 |
| Mean | 47.62926998 |
| MAD | 15.16018546 |
| Skewness | 0.2463963658 |
| Sum | 644185.8765 |
| Variance | 299.3984568 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=33)
Histogram with variable size bins (bins=[ 3.9641 13.175085 23.678585 25.53162571 25.95069344 ... 69.30594565 71.1723971 72.52544056 73.33140298 73.96371903], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 69.993 | 1745 | 12.9% | |
| 27.993 | 1366 | 10.1% | |
| 41.993 | 1305 | 9.6% | |
| 72.69908693 | 482 | 3.6% | |
| 43.54733751 | 482 | 3.6% | |
| 41.99333519 | 482 | 3.6% | |
| 42.27351194 | 481 | 3.6% | |
| 41.68006598 | 472 | 3.5% | |
| 68.6188913 | 459 | 3.4% | |
| 47.02866623 | 458 | 3.4% | |
| Other values (23) | 5793 | 42.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3.9641 | 1 | < 0.1% | |
| 4.193 | 2 | < 0.1% | |
| 22.15717 | 119 | 0.9% | |
| 25.2 | 97 | 0.7% | |
| 25.86325143 | 305 | 2.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 73.96371903 | 234 | 1.7% | |
| 72.69908693 | 482 | 3.6% | |
| 72.3517942 | 423 | 3.1% | |
| 69.993 | 1745 | 12.9% | |
| 68.6188913 | 459 | 3.4% |
Black.Friday
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 233 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 7342 | 54.3% | |
| 1 | 233 | 1.7% | |
| (Missing) | 5950 | 44.0% |
Christmas.Flag
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 467 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 7108 | 52.6% | |
| 1 | 467 | 3.5% | |
| (Missing) | 5950 | 44.0% |
day_of_Week
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Saturday | |
|---|---|
| Sunday | |
| Friday | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| Saturday | 1989 | 14.7% | |
| Sunday | 1962 | 14.5% | |
| Friday | 1955 | 14.5% | |
| Thursday | 1914 | 14.2% | |
| Tuesday | 1911 | 14.1% | |
| Wednesday | 1898 | 14.0% | |
| Monday | 1896 | 14.0% |
| Max length | 9 |
|---|---|
| Mean length | 7.139445471 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
days_since_launch
Numeric
| Distinct count | 483 |
|---|---|
| Unique (%) | 3.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 129.2476895 |
|---|---|
| Minimum | -138 |
| Maximum | 344 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | -138 |
|---|---|
| 5-th percentile | -93 |
| Q1 | 29 |
| Median | 132 |
| Q3 | 240 |
| 95-th percentile | 324 |
| Maximum | 344 |
| Range | 482 |
| Interquartile range | 211 |
Descriptive statistics
| Standard deviation | 128.435569 |
|---|---|
| Coef of variation | 0.9937165569 |
| Kurtosis | -1.00122549 |
| Mean | 129.2476895 |
| MAD | 109.6897266 |
| Skewness | -0.1589176913 |
| Sum | 1748075 |
| Variance | 16495.69537 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-138. -15.5 -1.5 75.5 344. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 277 | 39 | 0.3% | |
| 250 | 39 | 0.3% | |
| 233 | 39 | 0.3% | |
| 235 | 38 | 0.3% | |
| 245 | 38 | 0.3% | |
| 243 | 38 | 0.3% | |
| 251 | 38 | 0.3% | |
| 234 | 38 | 0.3% | |
| 248 | 38 | 0.3% | |
| 247 | 38 | 0.3% | |
| Other values (473) | 13142 | 97.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -138 | 4 | < 0.1% | |
| -137 | 11 | 0.1% | |
| -136 | 12 | 0.1% | |
| -135 | 11 | 0.1% | |
| -134 | 10 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 344 | 7 | 0.1% | |
| 343 | 33 | 0.2% | |
| 342 | 35 | 0.3% | |
| 341 | 33 | 0.2% | |
| 340 | 34 | 0.3% |
Discount_final
Categorical
| Distinct count | 71 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0% | |
|---|---|
| 60% | 717 |
| 50% | 620 |
| Other values (68) |
| Value | Count | Frequency (%) | |
| 0% | 9159 | 67.7% | |
| 60% | 717 | 5.3% | |
| 50% | 620 | 4.6% | |
| 40% | 479 | 3.5% | |
| 10% | 469 | 3.5% | |
| 25% | 165 | 1.2% | |
| 59% | 158 | 1.2% | |
| 17% | 145 | 1.1% | |
| 15% | 115 | 0.9% | |
| 67% | 106 | 0.8% | |
| Other values (61) | 1392 | 10.3% |
| Max length | 3 |
|---|---|
| Mean length | 2.298262477 |
| Min length | 2 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
dlc_event_flag
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 798 |
| Value | Count | Frequency (%) | |
| 0 | 12727 | 94.1% | |
| 1 | 798 | 5.9% |
Event
Categorical
| Distinct count | 25 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 94.1% |
| Missing (n) | 12727 |
| christmas | 38 |
|---|---|
| spawn launch | 37 |
| joker launch | 37 |
| Other values (21) | 686 |
| (Missing) |
| Value | Count | Frequency (%) | |
| christmas | 38 | 0.3% | |
| spawn launch | 37 | 0.3% | |
| joker launch | 37 | 0.3% | |
| shangtsung gameplay trailer | 36 | 0.3% | |
| shangtsung launch | 36 | 0.3% | |
| spawn early access | 35 | 0.3% | |
| spawn gameplay trailer | 35 | 0.3% | |
| sindel early access | 34 | 0.3% | |
| sindel launch | 34 | 0.3% | |
| klassic bundles update | 34 | 0.3% | |
| Other values (14) | 442 | 3.3% | |
| (Missing) | 12727 | 94.1% |
| Max length | 27 |
|---|---|
| Mean length | 3.93064695 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
F_Key
Categorical, Unique
| First 5 values |
|---|
| Matinee Skin Pack-Game-Steam-North America-Canada-341 |
| Matinee Skin Pack-Game-Steam-North America-United States-336 |
| Matinee Skin Pack-Game-Steam-North America-United States-339 |
| Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada--1 |
| Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada-0 |
| Last 5 values |
|---|
| Mortal Kombat 11-Game-XB1-North America-United States-95 |
| Mortal Kombat 11-Game-XB1-North America-United States-96 |
| Mortal Kombat 11-Game-XB1-North America-United States-97 |
| Mortal Kombat 11-Game-XB1-North America-United States-98 |
| Mortal Kombat 11-Game-XB1-North America-United States-99 |
First 5 values
| Value | Count | Frequency (%) | |
| Matinee Skin Pack-Game-Steam-North America-Canada-341 | 1 | < 0.1% | |
| Matinee Skin Pack-Game-Steam-North America-United States-336 | 1 | < 0.1% | |
| Matinee Skin Pack-Game-Steam-North America-United States-339 | 1 | < 0.1% | |
| Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada--1 | 1 | < 0.1% | |
| Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada-0 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| Mortal Kombat 11-Game-XB1-North America-United States-99 | 1 | < 0.1% | |
| Mortal Kombat 11-Game-XB1-North America-United States-98 | 1 | < 0.1% | |
| Mortal Kombat 11-Game-XB1-North America-United States-97 | 1 | < 0.1% | |
| Mortal Kombat 11-Game-XB1-North America-United States-96 | 1 | < 0.1% | |
| Mortal Kombat 11-Game-XB1-North America-United States-95 | 1 | < 0.1% |
FB_Spends
Numeric
| Distinct count | 248 |
|---|---|
| Unique (%) | 1.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6706.381442 |
|---|---|
| Minimum | 0 |
| Maximum | 76440 |
| Zeros (%) | 40.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 2522 |
| Q3 | 8439 |
| 95-th percentile | 24545 |
| Maximum | 76440 |
| Range | 76440 |
| Interquartile range | 8439 |
Descriptive statistics
| Standard deviation | 11578.62181 |
|---|---|
| Coef of variation | 1.726508089 |
| Kurtosis | 14.09422174 |
| Mean | 6706.381442 |
| MAD | 7053.365247 |
| Skewness | 3.441590292 |
| Sum | 90703809 |
| Variance | 134064483 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 106. 766. 1055.5 1073.5 ... 62597.5 62946. 64257. 76140. 76440. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 5429 | 40.1% | |
| 7840 | 71 | 0.5% | |
| 2883 | 38 | 0.3% | |
| 7978 | 38 | 0.3% | |
| 7930 | 38 | 0.3% | |
| 212 | 38 | 0.3% | |
| 47214 | 38 | 0.3% | |
| 1321 | 37 | 0.3% | |
| 24545 | 37 | 0.3% | |
| 3879 | 37 | 0.3% | |
| Other values (238) | 7724 | 57.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5429 | 40.1% | |
| 212 | 38 | 0.3% | |
| 744 | 33 | 0.2% | |
| 788 | 31 | 0.2% | |
| 892 | 29 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 76440 | 36 | 0.3% | |
| 75840 | 36 | 0.3% | |
| 65279 | 34 | 0.3% | |
| 63235 | 35 | 0.3% | |
| 62657 | 35 | 0.3% |
FB_Spends_Adstock_0.173
Highly correlated
This variable is highly correlated with FB_Spends and should be ignored for analysis
| Correlation | 0.9913990349 |
|---|
Festival.Flag
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 1087 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 6488 | 48.0% | |
| 1 | 1087 | 8.0% | |
| (Missing) | 5950 | 44.0% |
Fiscal_Month
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.194898336 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range | 6 |
Descriptive statistics
| Standard deviation | 3.650655883 |
|---|---|
| Coef of variation | 0.5893003702 |
| Kurtosis | -1.30107779 |
| Mean | 6.194898336 |
| MAD | 3.19772103 |
| Skewness | 0.1391317607 |
| Sum | 83786 |
| Variance | 13.32728838 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=12)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 8.5 11.5 12. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3 | 1573 | 11.6% | |
| 1 | 1508 | 11.1% | |
| 12 | 1429 | 10.6% | |
| 2 | 1329 | 9.8% | |
| 5 | 1056 | 7.8% | |
| 6 | 1042 | 7.7% | |
| 10 | 1027 | 7.6% | |
| 8 | 996 | 7.4% | |
| 7 | 992 | 7.3% | |
| 11 | 906 | 6.7% | |
| Other values (2) | 1667 | 12.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1508 | 11.1% | |
| 2 | 1329 | 9.8% | |
| 3 | 1573 | 11.6% | |
| 4 | 786 | 5.8% | |
| 5 | 1056 | 7.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12 | 1429 | 10.6% | |
| 11 | 906 | 6.7% | |
| 10 | 1027 | 7.6% | |
| 9 | 881 | 6.5% | |
| 8 | 996 | 7.4% |
Fiscal_Week
Highly correlated
This variable is highly correlated with Fiscal_Month and should be ignored for analysis
| Correlation | 0.9966852518 |
|---|
Fiscal_Year
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2019 | |
|---|---|
| 2020 | |
| 2018 | 373 |
| Value | Count | Frequency (%) | |
| 2019 | 10226 | 75.6% | |
| 2020 | 2926 | 21.6% | |
| 2018 | 373 | 2.8% |
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Free.Trial.Week
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 72 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 7503 | 55.5% | |
| 1 | 72 | 0.5% | |
| (Missing) | 5950 | 44.0% |
Free.Trial.Week.Lag1
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 116 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 7459 | 55.1% | |
| 1 | 116 | 0.9% | |
| (Missing) | 5950 | 44.0% |
Free.Trial.Week.Lag2
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 86.7% |
| Missing (n) | 11724 |
| 0 | 1787 |
|---|---|
| 1 | 14 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 1787 | 13.2% | |
| 1 | 14 | 0.1% | |
| (Missing) | 11724 | 86.7% |
game_name
Constant
This variable is constant and should be ignored for analysis
| Constant value | Mortal Kombat 11 |
|---|
geo_region
Constant
This variable is constant and should be ignored for analysis
| Constant value | North America |
|---|
geo_subregion
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| United States | |
|---|---|
| Canada | |
| Mexico |
| Value | Count | Frequency (%) | |
| United States | 5071 | 37.5% | |
| Canada | 4497 | 33.2% | |
| Mexico | 3936 | 29.1% | |
| Other NA | 21 | 0.2% |
| Max length | 13 |
|---|---|
| Mean length | 8.627652495 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Halloween
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 387 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 7188 | 53.1% | |
| 1 | 387 | 2.9% | |
| (Missing) | 5950 | 44.0% |
Holiday
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 54 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 7521 | 55.6% | |
| 1 | 54 | 0.4% | |
| (Missing) | 5950 | 44.0% |
lifecycle
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 3. 121+ days | |
|---|---|
| 1. 0 - 80 days | |
| 0.Pre-Launch |
| Value | Count | Frequency (%) | |
| 3. 121+ days | 7122 | 52.7% | |
| 1. 0 - 80 days | 2782 | 20.6% | |
| 0.Pre-Launch | 2357 | 17.4% | |
| 2. 81 - 121 days | 1264 | 9.3% |
| Max length | 16 |
|---|---|
| Mean length | 12.99090573 |
| Min length | 12 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
New_Week_Since_Launch
Highly correlated
This variable is highly correlated with days_since_launch and should be ignored for analysis
| Correlation | 0.9998798641 |
|---|
Pkey
Categorical
| Distinct count | 44 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mortal Kombat 11-Game-PS4-North America-United States | 482 |
|---|---|
| Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States | 482 |
| Mortal Kombat 11-Game-Steam-North America-United States | 482 |
| Other values (41) |
| Value | Count | Frequency (%) | |
| Mortal Kombat 11-Game-PS4-North America-United States | 482 | 3.6% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States | 482 | 3.6% | |
| Mortal Kombat 11-Game-Steam-North America-United States | 482 | 3.6% | |
| Mortal Kombat 11-Game-PS4-North America-Canada | 481 | 3.6% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United States | 479 | 3.5% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United States | 477 | 3.5% | |
| Mortal Kombat 11-Game-XB1-North America-United States | 477 | 3.5% | |
| Mortal Kombat 11-Game-XB1-North America-Canada | 472 | 3.5% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada | 459 | 3.4% | |
| Mortal Kombat 11-Game-XB1-North America-Mexico | 458 | 3.4% | |
| Other values (34) | 8776 | 64.9% |
| Max length | 79 |
|---|---|
| Mean length | 61.31275416 |
| Min length | 46 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
platform
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| PS4 | |
|---|---|
| XB1 | |
| Steam |
| Value | Count | Frequency (%) | |
| PS4 | 3810 | 28.2% | |
| XB1 | 3765 | 27.8% | |
| Steam | 3161 | 23.4% | |
| Switch | 2789 | 20.6% |
| Max length | 6 |
|---|---|
| Mean length | 4.086062847 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Post.Holiday.Flag
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 342 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 7233 | 53.5% | |
| 1 | 342 | 2.5% | |
| (Missing) | 5950 | 44.0% |
Pre.Holiday.Flag
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 44.0% |
| Missing (n) | 5950 |
| 0 | |
|---|---|
| 1 | 602 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 6973 | 51.6% | |
| 1 | 602 | 4.5% | |
| (Missing) | 5950 | 44.0% |
Price
Numeric
| Distinct count | 28 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 86.7% |
| Missing (n) | 11724 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 53.58662543 |
|---|---|
| Minimum | 23.996 |
| Maximum | 59.99 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 23.996 |
|---|---|
| 5-th percentile | 23.996 |
| Q1 | 56.3906 |
| Median | 59.99 |
| Q3 | 59.99 |
| 95-th percentile | 59.99 |
| Maximum | 59.99 |
| Range | 35.994 |
| Interquartile range | 3.5994 |
Descriptive statistics
| Standard deviation | 12.02905196 |
|---|---|
| Coef of variation | 0.2244786243 |
| Kurtosis | 0.8192923135 |
| Mean | 53.58662543 |
| MAD | 9.604623896 |
| Skewness | -1.573142727 |
| Sum | 96509.5124 |
| Variance | 144.6980911 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) | |
| 59.99 | 1350 | 10.0% | |
| 23.996 | 104 | 0.8% | |
| 29.995 | 95 | 0.7% | |
| 35.994 | 72 | 0.5% | |
| 49.7917 | 48 | 0.4% | |
| 44.9925 | 39 | 0.3% | |
| 41.993 | 19 | 0.1% | |
| 24.5959 | 18 | 0.1% | |
| 45.5924 | 14 | 0.1% | |
| 25.1958 | 14 | 0.1% | |
| Other values (17) | 28 | 0.2% | |
| (Missing) | 11724 | 86.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 23.996 | 104 | 0.8% | |
| 24.5959 | 18 | 0.1% | |
| 25.1958 | 14 | 0.1% | |
| 26.3956 | 2 | < 0.1% | |
| 26.9955 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 59.99 | 1350 | 10.0% | |
| 56.3906 | 1 | < 0.1% | |
| 55.1908 | 1 | < 0.1% | |
| 53.3911 | 1 | < 0.1% | |
| 52.1913 | 1 | < 0.1% |
Promo
Categorical
| Distinct count | 43 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 79.7% |
| Missing (n) | 10774 |
| black friday sale | 224 |
|---|---|
| psn global holiday sale | 162 |
| sale of the dead/halloween americas | 156 |
| Other values (39) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| black friday sale | 224 | 1.7% | |
| psn global holiday sale | 162 | 1.2% | |
| sale of the dead/halloween americas | 156 | 1.2% | |
| winter sale | 136 | 1.0% | |
| countdown | 135 | 1.0% | |
| steam summer sale | 125 | 0.9% | |
| wb publisher sale | 103 | 0.8% | |
| mk 11 free play / pub sale | 99 | 0.7% | |
| sony summer sale | 89 | 0.7% | |
| joker promo | 81 | 0.6% | |
| Other values (32) | 1441 | 10.7% | |
| (Missing) | 10774 | 79.7% |
| Max length | 47 |
|---|---|
| Mean length | 6.420628466 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
pweek
Categorical
| Distinct count | 2178 |
|---|---|
| Unique (%) | 16.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mortal Kombat 11-Game-PS4-North America-Canada-0 | 13 |
|---|---|
| Mortal Kombat 11-Game-PS4-North America-Mexico-0 | 13 |
| Mortal Kombat 11-Game-XB1-North America-Mexico-0 | 13 |
| Other values (2175) |
| Value | Count | Frequency (%) | |
| Mortal Kombat 11-Game-PS4-North America-Canada-0 | 13 | 0.1% | |
| Mortal Kombat 11-Game-PS4-North America-Mexico-0 | 13 | 0.1% | |
| Mortal Kombat 11-Game-XB1-North America-Mexico-0 | 13 | 0.1% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada-0 | 13 | 0.1% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States-0 | 13 | 0.1% | |
| Mortal Kombat 11-Game-XB1-North America-Canada-0 | 13 | 0.1% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Mexico-0 | 13 | 0.1% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-Mexico-0 | 13 | 0.1% | |
| Mortal Kombat 11-Game-Switch-North America-Mexico-0 | 13 | 0.1% | |
| Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Canada-0 | 13 | 0.1% | |
| Other values (2168) | 13395 | 99.0% |
| Max length | 82 |
|---|---|
| Mean length | 64.20118299 |
| Min length | 48 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
revenue_usd
Numeric
| Distinct count | 9723 |
|---|---|
| Unique (%) | 71.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5833.434703 |
|---|---|
| Minimum | -159.271 |
| Maximum | 1355393.641 |
| Zeros (%) | 0.7% |
Quantile statistics
| Minimum | -159.271 |
|---|---|
| 5-th percentile | 41.05660968 |
| Q1 | 138.18203 |
| Median | 539.21091 |
| Q3 | 2379.762 |
| 95-th percentile | 21726.8562 |
| Maximum | 1355393.641 |
| Range | 1355552.912 |
| Interquartile range | 2241.57997 |
Descriptive statistics
| Standard deviation | 34568.51938 |
|---|---|
| Coef of variation | 5.925928915 |
| Kurtosis | 614.2325785 |
| Mean | 5833.434703 |
| MAD | 8394.640377 |
| Skewness | 21.3810817 |
| Sum | 78897204.36 |
| Variance | 1194982532 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-1.59271000e+02 -6.98302850e+01 -6.48410000e+01 -4.42330000e+01 -4.10856600e+01 ... 7.27116915e+04 1.12598878e+05 2.74970164e+05 6.48312787e+05 1.35539364e+06], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 96 | 0.7% | |
| 139.986 | 62 | 0.5% | |
| 83.979 | 59 | 0.4% | |
| 41.993 | 57 | 0.4% | |
| 69.993 | 53 | 0.4% | |
| 55.986 | 53 | 0.4% | |
| 111.972 | 51 | 0.4% | |
| 209.979 | 49 | 0.4% | |
| 83.986 | 47 | 0.3% | |
| 125.979 | 47 | 0.3% | |
| Other values (9713) | 12951 | 95.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -159.271 | 1 | < 0.1% | |
| -138.565 | 1 | < 0.1% | |
| -134.52439 | 1 | < 0.1% | |
| -130.0852 | 1 | < 0.1% | |
| -125.671 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1355393.641 | 1 | < 0.1% | |
| 1332017.96 | 1 | < 0.1% | |
| 1130793.713 | 1 | < 0.1% | |
| 1016858.304 | 1 | < 0.1% | |
| 876981.812 | 1 | < 0.1% |
sku_name
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mortal Kombat 11 | |
|---|---|
| Mortal Kombat 11 Premium Edition | |
| Mortal Kombat 11 - Kombat Pack |
| Value | Count | Frequency (%) | |
| Mortal Kombat 11 | 5043 | 37.3% | |
| Mortal Kombat 11 Premium Edition | 4783 | 35.4% | |
| Mortal Kombat 11 - Kombat Pack | 3696 | 27.3% | |
| Matinee Skin Pack | 3 | < 0.1% |
| Max length | 32 |
|---|---|
| Mean length | 25.48428835 |
| Min length | 16 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
sku_name.1
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mortal Kombat 11-Game | |
|---|---|
| Mortal Kombat 11 Premium Edition-Game Bundle | |
| Mortal Kombat 11 - Kombat Pack-DLC | |
| Other values (2) | 172 |
| Value | Count | Frequency (%) | |
| Mortal Kombat 11-Game | 5043 | 37.3% | |
| Mortal Kombat 11 Premium Edition-Game Bundle | 4614 | 34.1% | |
| Mortal Kombat 11 - Kombat Pack-DLC | 3696 | 27.3% | |
| Mortal Kombat 11 Premium Edition-Game | 169 | 1.2% | |
| Matinee Skin Pack-Game | 3 | < 0.1% |
| Max length | 44 |
|---|---|
| Mean length | 32.59903882 |
| Min length | 21 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
sku_type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Game | |
|---|---|
| Game Bundle | |
| DLC |
| Value | Count | Frequency (%) | |
| Game | 5215 | 38.6% | |
| Game Bundle | 4614 | 34.1% | |
| DLC | 3696 | 27.3% |
| Max length | 11 |
|---|---|
| Mean length | 6.114750462 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
transaction_date
Categorical
| Distinct count | 483 |
|---|---|
| Unique (%) | 3.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 29-12-2019 | 39 |
|---|---|
| 12/12/2019 | 39 |
| 25-01-2020 | 39 |
| Other values (480) |
| Value | Count | Frequency (%) | |
| 29-12-2019 | 39 | 0.3% | |
| 12/12/2019 | 39 | 0.3% | |
| 25-01-2020 | 39 | 0.3% | |
| 27-12-2019 | 38 | 0.3% | |
| 24-12-2019 | 38 | 0.3% | |
| 25-04-2019 | 38 | 0.3% | |
| 22-12-2019 | 38 | 0.3% | |
| 25-12-2019 | 38 | 0.3% | |
| 1/2/2020 | 38 | 0.3% | |
| 30-12-2019 | 38 | 0.3% | |
| Other values (473) | 13142 | 97.2% |
| Max length | 10 |
|---|---|
| Mean length | 9.421072089 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
units_base
Numeric
| Distinct count | 35 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 1.3% |
| Missing (n) | 182 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3186.163531 |
|---|---|
| Minimum | 2 |
| Maximum | 31720 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 72 |
| Median | 322 |
| Q3 | 1340 |
| 95-th percentile | 25967 |
| Maximum | 31720 |
| Range | 31718 |
| Interquartile range | 1268 |
Descriptive statistics
| Standard deviation | 7422.637995 |
|---|---|
| Coef of variation | 2.329647528 |
| Kurtosis | 8.037635137 |
| Mean | 3186.163531 |
| MAD | 4383.428712 |
| Skewness | 3.038363616 |
| Sum | 42512980 |
| Variance | 55095554.81 |
| Memory size | 105.8 KiB |
Histogram with fixed size bins (bins=35)
| Value | Count | Frequency (%) | |
| 14 | 582 | 4.3% | |
| 39 | 539 | 4.0% | |
| 4497 | 482 | 3.6% | |
| 25967 | 482 | 3.6% | |
| 6327 | 482 | 3.6% | |
| 1340 | 481 | 3.6% | |
| 702 | 479 | 3.5% | |
| 31720 | 477 | 3.5% | |
| 6002 | 477 | 3.5% | |
| 1012 | 472 | 3.5% | |
| Other values (24) | 8390 | 62.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 130 | 1.0% | |
| 7 | 305 | 2.3% | |
| 11 | 239 | 1.8% | |
| 14 | 582 | 4.3% | |
| 17 | 333 | 2.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 31720 | 477 | 3.5% | |
| 25967 | 482 | 3.6% | |
| 6420 | 360 | 2.7% | |
| 6327 | 482 | 3.6% | |
| 6002 | 477 | 3.5% |
units_sold
Highly correlated
This variable is highly correlated with revenue_usd and should be ignored for analysis
| Correlation | 0.9636180616 |
|---|
First rows
| asp_new | base_asp | Black.Friday | Christmas.Flag | day_of_Week | days_since_launch | Discount_final | dlc_event_flag | Event | F_Key | FB_Spends | FB_Spends_Adstock_0.173 | Festival.Flag | Fiscal_Month | Fiscal_Week | Fiscal_Year | Free.Trial.Week | Free.Trial.Week.Lag1 | Free.Trial.Week.Lag2 | game_name | geo_region | geo_subregion | Halloween | Holiday | lifecycle | New_Week_Since_Launch | Pkey | platform | Post.Holiday.Flag | Pre.Holiday.Flag | Price | Promo | pweek | revenue_usd | sku_name | sku_name.1 | sku_type | transaction_date | units_base | units_sold | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 41.874000 | 41.609054 | NaN | NaN | Thursday | -138 | 0% | 0 | NaN | Mortal Kombat 11-Game-Steam-North America-Canada--138 | 0 | 0.0 | NaN | 12 | 49 | 2018 | NaN | NaN | NaN | Mortal Kombat 11 | North America | Canada | NaN | NaN | 0.Pre-Launch | -20 | Mortal Kombat 11-Game-Steam-North America-Canada | Steam | NaN | NaN | NaN | NaN | Mortal Kombat 11-Game-Steam-North America-Canada--19 | 83.748 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 6/12/2018 | 448.0 | 2 |
| 1 | 41.993000 | 41.993335 | NaN | NaN | Thursday | -138 | 0% | 0 | NaN | Mortal Kombat 11-Game-Steam-North America-United States--138 | 0 | 0.0 | NaN | 12 | 49 | 2018 | NaN | NaN | 0.0 | Mortal Kombat 11 | North America | United States | NaN | NaN | 0.Pre-Launch | -20 | Mortal Kombat 11-Game-Steam-North America-United States | Steam | NaN | NaN | 59.99 | NaN | Mortal Kombat 11-Game-Steam-North America-United States--19 | 755.874 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 6/12/2018 | 4497.0 | 18 |
| 2 | 68.376000 | 67.537143 | NaN | NaN | Thursday | -138 | 0% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-Canada--138 | 0 | 0.0 | NaN | 12 | 49 | 2018 | NaN | NaN | NaN | Mortal Kombat 11 | North America | Canada | NaN | NaN | 0.Pre-Launch | -20 | Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-Canada | Steam | NaN | NaN | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-Canada--19 | 136.752 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 6/12/2018 | 62.0 | 2 |
| 3 | 69.993000 | 69.993000 | NaN | NaN | Thursday | -138 | 0% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United States--138 | 0 | 0.0 | NaN | 12 | 49 | 2018 | NaN | NaN | NaN | Mortal Kombat 11 | North America | United States | NaN | NaN | 0.Pre-Launch | -20 | Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United States | Steam | NaN | NaN | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United States--19 | 1539.846 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 6/12/2018 | 702.0 | 22 |
| 4 | 42.072333 | 42.273512 | 0.0 | 0.0 | Friday | -137 | 0% | 0 | NaN | Mortal Kombat 11-Game-PS4-North America-Canada--137 | 0 | 0.0 | 0.0 | 12 | 49 | 2018 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | Canada | 0.0 | 0.0 | 0.Pre-Launch | -20 | Mortal Kombat 11-Game-PS4-North America-Canada | PS4 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11-Game-PS4-North America-Canada--19 | 126.217 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 7/12/2018 | 1340.0 | 3 |
| 5 | 41.993000 | 41.993000 | 0.0 | 0.0 | Friday | -137 | 0% | 0 | NaN | Mortal Kombat 11-Game-PS4-North America-Mexico--137 | 0 | 0.0 | 0.0 | 12 | 49 | 2018 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | Mexico | 0.0 | 0.0 | 0.Pre-Launch | -20 | Mortal Kombat 11-Game-PS4-North America-Mexico | PS4 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11-Game-PS4-North America-Mexico--19 | 83.986 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 7/12/2018 | 186.0 | 2 |
| 6 | 43.699200 | 43.547338 | 0.0 | 0.0 | Friday | -137 | 0% | 0 | NaN | Mortal Kombat 11-Game-PS4-North America-United States--137 | 0 | 0.0 | 0.0 | 12 | 49 | 2018 | 0.0 | 0.0 | 0.0 | Mortal Kombat 11 | North America | United States | 0.0 | 0.0 | 0.Pre-Launch | -20 | Mortal Kombat 11-Game-PS4-North America-United States | PS4 | 0.0 | 0.0 | 59.99 | NaN | Mortal Kombat 11-Game-PS4-North America-United States--19 | 4588.416 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 7/12/2018 | 25967.0 | 105 |
| 7 | 68.371917 | 68.618891 | 0.0 | 0.0 | Friday | -137 | 0% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada--137 | 0 | 0.0 | 0.0 | 12 | 49 | 2018 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | Canada | 0.0 | 0.0 | 0.Pre-Launch | -20 | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada | PS4 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada--19 | 820.463 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 7/12/2018 | 322.0 | 12 |
| 8 | 69.993000 | 69.993000 | 0.0 | 0.0 | Friday | -137 | 0% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Mexico--137 | 0 | 0.0 | 0.0 | 12 | 49 | 2018 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | Mexico | 0.0 | 0.0 | 0.Pre-Launch | -20 | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Mexico | PS4 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Mexico--19 | 209.979 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 7/12/2018 | 72.0 | 3 |
| 9 | 72.482667 | 72.699087 | 0.0 | 0.0 | Friday | -137 | 0% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States--137 | 0 | 0.0 | 0.0 | 12 | 49 | 2018 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | United States | 0.0 | 0.0 | 0.Pre-Launch | -20 | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States | PS4 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States--19 | 8263.024 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 7/12/2018 | 6327.0 | 114 |
Last rows
| asp_new | base_asp | Black.Friday | Christmas.Flag | day_of_Week | days_since_launch | Discount_final | dlc_event_flag | Event | F_Key | FB_Spends | FB_Spends_Adstock_0.173 | Festival.Flag | Fiscal_Month | Fiscal_Week | Fiscal_Year | Free.Trial.Week | Free.Trial.Week.Lag1 | Free.Trial.Week.Lag2 | game_name | geo_region | geo_subregion | Halloween | Holiday | lifecycle | New_Week_Since_Launch | Pkey | platform | Post.Holiday.Flag | Pre.Holiday.Flag | Price | Promo | pweek | revenue_usd | sku_name | sku_name.1 | sku_type | transaction_date | units_base | units_sold | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13515 | 68.403090 | 67.733364 | 0.0 | 0.0 | Tuesday | 343 | 0% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Canada-343 | 0 | 112.93 | 0.0 | 3 | 13 | 2020 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | Canada | 0.0 | 0.0 | 3. 121+ days | 49 | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Canada | XB1 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Canada-49 | 136.80618 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 31-03-2020 | 279.0 | 2 |
| 13516 | 73.160500 | 72.351794 | 0.0 | 0.0 | Tuesday | 343 | 0% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Mexico-343 | 0 | 112.93 | 0.0 | 3 | 13 | 2020 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | Mexico | 0.0 | 0.0 | 3. 121+ days | 49 | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Mexico | XB1 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Mexico-49 | 73.16050 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 31-03-2020 | 237.0 | 1 |
| 13517 | 62.993000 | 69.993000 | 0.0 | 0.0 | Tuesday | 343 | 10% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United States-343 | 0 | 112.93 | 0.0 | 3 | 13 | 2020 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | United States | 0.0 | 0.0 | 3. 121+ days | 49 | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United States | XB1 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United States-49 | 4094.54500 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 31-03-2020 | 6002.0 | 65 |
| 13518 | 43.694000 | 43.547338 | 0.0 | 0.0 | Wednesday | 344 | 0% | 0 | NaN | Mortal Kombat 11-Game-PS4-North America-United States-344 | 0 | 19.54 | 0.0 | 4 | 14 | 2020 | 0.0 | 0.0 | 0.0 | Mortal Kombat 11 | North America | United States | 0.0 | 0.0 | 3. 121+ days | 49 | Mortal Kombat 11-Game-PS4-North America-United States | PS4 | 0.0 | 0.0 | 59.99 | NaN | Mortal Kombat 11-Game-PS4-North America-United States-49 | 218.47000 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 1/4/2020 | 25967.0 | 5 |
| 13519 | 29.375500 | 29.114464 | 0.0 | 0.0 | Wednesday | 344 | 0% | 0 | NaN | Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-United States-344 | 0 | 19.54 | 0.0 | 4 | 14 | 2020 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | United States | 0.0 | 0.0 | 3. 121+ days | 49 | Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-United States | PS4 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-United States-49 | 117.50200 | Mortal Kombat 11 - Kombat Pack | Mortal Kombat 11 - Kombat Pack-DLC | DLC | 1/4/2020 | 2046.0 | 4 |
| 13520 | 66.235750 | 72.699087 | 0.0 | 0.0 | Wednesday | 344 | 9% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States-344 | 0 | 19.54 | 0.0 | 4 | 14 | 2020 | 0.0 | 0.0 | NaN | Mortal Kombat 11 | North America | United States | 0.0 | 0.0 | 3. 121+ days | 49 | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States | PS4 | 0.0 | 0.0 | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States-49 | 264.94300 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 1/4/2020 | 6327.0 | 4 |
| 13521 | 38.255713 | 48.063467 | NaN | NaN | Wednesday | 344 | 20% | 0 | NaN | Mortal Kombat 11-Game-Switch-North America-Mexico-344 | 0 | 19.54 | NaN | 4 | 14 | 2020 | NaN | NaN | NaN | Mortal Kombat 11 | North America | Mexico | NaN | NaN | 3. 121+ days | 49 | Mortal Kombat 11-Game-Switch-North America-Mexico | Switch | NaN | NaN | NaN | NaN | Mortal Kombat 11-Game-Switch-North America-Mexico-49 | 0.00000 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 1/4/2020 | 108.0 | 1 |
| 13522 | 41.993000 | 41.993000 | NaN | NaN | Wednesday | 344 | 0% | 0 | NaN | Mortal Kombat 11-Game-Switch-North America-United States-344 | 0 | 19.54 | NaN | 4 | 14 | 2020 | NaN | NaN | 0.0 | Mortal Kombat 11 | North America | United States | NaN | NaN | 3. 121+ days | 49 | Mortal Kombat 11-Game-Switch-North America-United States | Switch | NaN | NaN | 59.99 | NaN | Mortal Kombat 11-Game-Switch-North America-United States-49 | 0.00000 | Mortal Kombat 11 | Mortal Kombat 11-Game | Game | 1/4/2020 | 6420.0 | 2 |
| 13523 | 27.993000 | 27.993000 | NaN | NaN | Wednesday | 344 | 0% | 0 | NaN | Mortal Kombat 11 - Kombat Pack-DLC-Switch-North America-United States-344 | 0 | 19.54 | NaN | 4 | 14 | 2020 | NaN | NaN | NaN | Mortal Kombat 11 | North America | United States | NaN | NaN | 3. 121+ days | 49 | Mortal Kombat 11 - Kombat Pack-DLC-Switch-North America-United States | Switch | NaN | NaN | NaN | NaN | Mortal Kombat 11 - Kombat Pack-DLC-Switch-North America-United States-49 | 0.00000 | Mortal Kombat 11 - Kombat Pack | Mortal Kombat 11 - Kombat Pack-DLC | DLC | 1/4/2020 | 731.0 | 1 |
| 13524 | 62.993000 | 69.993000 | NaN | NaN | Wednesday | 344 | 10% | 0 | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-Switch-North America-United States-344 | 0 | 19.54 | NaN | 4 | 14 | 2020 | NaN | NaN | NaN | Mortal Kombat 11 | North America | United States | NaN | NaN | 3. 121+ days | 49 | Mortal Kombat 11 Premium Edition-Game Bundle-Switch-North America-United States | Switch | NaN | NaN | NaN | NaN | Mortal Kombat 11 Premium Edition-Game Bundle-Switch-North America-United States-49 | 0.00000 | Mortal Kombat 11 Premium Edition | Mortal Kombat 11 Premium Edition-Game Bundle | Game Bundle | 1/4/2020 | 969.0 | 1 |